home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Business Assistant
/
Business Assistant.iso
/
stock
/
pa005a
/
ffile
< prev
next >
Wrap
Text File
|
1980-01-01
|
13KB
|
275 lines
FILE DESCRIPTIONS
AN IMPORTANT NOTE:
Before you start using this section, we first need to discuss the three
different types of "fields" in your files and listed in the "File
Descriptions" section of the manual, in other words the three "types"
of information" you keep on the system. They are:
(1) "Character" Fields
(2) "Numeric" Fields
(3) "Date" Fields
"Character" fields refers to an information area, such as "Family
Code", in which you may enter characters or numbers or symbols (ie. $
or %). Now, if you or I heard that something was a "character" field,
we would think that it meant only the letters "A" through "Z", the
alphabet, could be keyed in that field. But computers work a little
differently. A "Character" (or "Alphanumeric" as its known to
programmers) field means you can type anything you want. As a result, a
Family Code can be entered not just as "ABCD" but also as "AB234" or
even "AB#345%" if you wanted. Other examples where you may combine
numbers, characters and symbols in a "character" field include a
street address or phone number. And you may even have a "character"
field of "Zip Code" that contains just numbers.
"Numeric" fields are a little more straight-forward. They contain only
numbers, and cannot contain any characters or symbols, other than a "."
used as a decimal place. In addition, these fields contain numbers that
are used in calculations. That's why "Amount" is a "numeric" field, an
"Zip Code" is not. Because "Amount" is totaled and/or manipulated in
many ways in several different reports. On the other hand, "Zip Code"
is just displayed or printed for informational purposes. You won't find
many reports anywhere that literally add up two zip codes and print the
total.
"Date" fields are even more basic. They contain calendar dates, which
are entered with numbers in Month-Day-Year (MM/DD/YY) fashion when you
key them in. So, if the field "Purchase Date" is a "Date" field, and
the item was purchased on February 1st of 1986, then "02/01/86" would
be the purchase date.
JOURNAL ENTRIES (GLEDG.DBF)
DATA
NAME DESCRIPTION TYPE LENGTH
---------- ----------------------------------- ---------- ------
DATE TRANSACTION DATE MM/DD/YY 8
COMPANY COMPANY OR INDIVIDUAL INVOLVED CHARACTERS 30
DESC DESCRIPTION OF THE TRANSACTION CHARACTERS 65
DEBIT THIS WHERE YOU ENTER THE FUND NUMBER, ACCOUNT NUMBER,
ACCOUNT 1-3 AND PROJECT NUMBERS FOR UP TO THREE DEBIT ENTRIES. THE
FUND NUMBER IS TWO NUMBERS LONG, THE ACCOUNT NUMBER IS
FOUR NUMBERS AND THE PROJECT NUMBER CAN BE UP TO ELEVEN
NUMBERS LONG.
DEBIT THIS IS WHERE YOU ENTER THE AMOUNT FOR EACH OF THE THREE
AMOUNT DEBIT ENTRIES. THE SYSTEM WILL THEN TOTAL THE TRANSACTION
AMOUNT.
DEBIT IF YOU PREFER, YOU CAN ENTER WHAT PERCENTAGE OF THE
PERCENTAGE TRANSACTION AMOUNT EACH ENTRY IS AND THEN LET THE SYSTEM
FIGURE OUT EACH AMOUNT.
CREDIT THIS WHERE YOU ENTER THE FUND NUMBER, ACCOUNT NUMBER, AND
ACCOUNT 1-3 PROJECT NUMBERS FOR UP TO CREDIT DEBIT ENTRIES. THE FUND
NUMBER IS TWO NUMBERS LONG, THE ACCOUNT NUMBER IS FOUR
NUMBERS AND THE PROJECT NUMBER CAN BE UP TO ELEVEN
NUMBERS LONG.
CREDIT THIS IS WHERE YOU ENTER THE AMOUNT FOR EACH OF THE THREE
AMOUNT DEBIT ENTRIES. THE SYSTEM WILL THEN TOTAL THE TRANSACTION
AMOUNT.
CREDIT IF YOU PREFER, YOU CAN ENTER WHAT PERCENTAGE OF THE
PERCENTAGE TRANSACTION AMOUNT EACH ENTRY IS AND THEN LET THE SYSTEM
FIGURE OUT EACH AMOUNT.
AMOUNT THE TOTAL AMOUNT OF THE TRANSACTION NUMBERS 10
CHECK_NO THE CHECK NUMBER (IF ANY) CHARACTERS 10
CHECKBOOK THE CHECKBOOK WHICH WAS USED CHARACTERS 1
FIXED ASSET SCHEDULE (IHVENT.DBF)
DATA
NAME DESCRIPTION TYPE LENGTH
---------- ----------------------------------- ---------- ------
EQUIP_NO EQUIPMENT NUMBER CHARACTERS 10
PROD_NAME PRODUCT NAME CHARACTERS 25
DESCRIPT PRODUCT DESCRIPTION CHARACTERS 60
SERIAL_NUM SERIAL NUMBER CHARACTERS 15
MFG MANUFACTURER CHARACTERS 25
VENDOR VENDOR CHARACTERS 25
PURCH_DATE DATE OF PURCHASE MM/DD/YY 8
PURCH_COST PURCHASE COST NUMBERS 10
CURR_VALUE CURRENT VALUE AFTER DEPRECIATION NUMBERS 10
LEASE IS IT LEASED? (Y OR N) CHARACTERS 1
LEASE_AMT LEASE PAYMENT AMOUNT NUMBERS 10
LEASE_PER LEASE PAYMENT PERIOD (IE. MONTHLY) CHARACTERS 10
LSTART DATE LEASE STARTED MM/DD/YY 8
LEXPIRE DATE LEASE ENDS MM/DD/YY 8
ACCOUNT FUND,ACCOUNT & PROJECT NUMBER CHARACTERS 19
CATEGORY CATEGORY (IE. MONITORS) CHARACTERS 20
LOCATION ITEM'S PHYSICAL LOCATION CHARACTERS 30
WARRANTY WARRANTY TERMS CHARACTERS 30
WARR_EXP WARRANTY EXPIRATION MM/DD/YY 8
MAINT_AGR IS THERE A MAINTENANCE AGREEMENT? CHARACTERS 1
MAINT_CO MAINTENANCE COMPANY CHARACTERS 25
START AGREEMENT START DATE MM/DD/YY 8
EXPIRE AGREEMENT ENDING DATE MM/DD/YY 8
MAINT_FEE MAINTENANCE FEE NUMBERS 10
PAY_PERIOD MAINTENANCE PAYMENT PERIOD CHARACTERS 10
REMARKS ANY REMARKS YOU WANT TO ADD CHARACTERS 60
LIABILITIES SCHEDULE (LLIAB.DBF)
DATA
NAME DESCRIPTION TYPE LENGTH
---------- ----------------------------------- ---------- ------
LOAN_NO LOAN NUMBER ASSIGNED TO THIS NOTE CHARACTERS 15
CREDITOR CREDITOR'S NAME CHARACTERS 15
PURPOSE PURPOSE FOR THE NOTE CHARACTERS 15
INT_RATE INTEREST RATE NUMBERS 15
COMPOUNDED HOW COMPOUNDED CHARACTERS 15
LENGTH LENGTH OF THE LIABILITY CHARACTERS 15
PAY_FREQ PAYMENT FREQUENCY CHARACTERS 15
PAY_AMT PAYMENT AMOUNT NUMBERS 15
COLLATERAL WHAT COLLATERAL (IF ANY) WAS USED CHARACTERS 15
ORIG_DATE DATE LIABILITY WAS INCURRED MM/DD/YY 15
MATUR_DATE WHEN THE NOTE MATURES MM/DD/YY 15
PAYOFF THE NOTE'S PAYOFF AMOUNT CHARACTERS 15
ORIG_BAL THE ORIGINAL BALANCE CHARACTERS 15
CURR_BAL THE CURRENT BALANCE CHARACTERS 15
PRINCIPAL THIS WHERE YOU ENTER THE FUND NUMBER, ACCOUNT NUMBER, AND
ACCOUNT PROJECT NUMBERS FOR THE PAYMENT OF PRINCIPAL. THE FUND
NUMBER IS TWO NUMBERS LONG, THE ACCOUNT NUMBER IS FOUR
NUMBERS AND THE PROJECT NUMBER CAN BE UP TO ELEVEN
NUMBERS LONG.
INTEREST THIS WHERE YOU ENTER THE FUND NUMBER, ACCOUNT NUMBER, AND
ACCOUNT PROJECT NUMBERS FOR THE PAYMENT OF INTEREST. THE FUND
NUMBER IS TWO NUMBERS LONG, THE ACCOUNT NUMBER IS FOUR
NUMBERS AND THE PROJECT NUMBER CAN BE UP TO ELEVEN
NUMBERS LONG.
INSURANCE THIS WHERE YOU ENTER THE FUND NUMBER, ACCOUNT NUMBER, AND
ACCOUNT PROJECT NUMBERS FOR THE PAYMENT OF INSURANCE. THE FUND
NUMBER IS TWO NUMBERS LONG, THE ACCOUNT NUMBER IS FOUR
NUMBERS AND THE PROJECT NUMBER CAN BE UP TO ELEVEN NUMBERS
LONG.
TAXES THIS WHERE YOU EN